﻿CREATE PROCEDURE [dbo].[GetAllHours]
@startDate DATETIME, @endDate DATETIME
AS
select EntryDate, Duration as Hours,Name as ProjectName,UserName from EntryLog e, Projects p, Users u
where EntryDate >= @startDate and EntryDate <= @endDate  and e.projectid=p.projectid and e.userid = u.userid 
order by EntryDate,p.Name,UserName


